package wetogether.travelinfo.service;

import java.sql.SQLException;
import java.util.List;

import wetogether.travelinfo.vo.TravelCommentVO;
import wetogether.travelinfo.vo.TravelFrVO;
import wetogether.travelinfo.vo.TravelImageVO;
import wetogether.travelinfo.vo.TravelInfoVO;
import wetogether.travelinfo.vo.TravelVacancyVO;
import wetogether.travelinfo.vo.TravelZoneVO;

public interface InputTravelInfoService {
	public void insertTravelZone(TravelZoneVO zoneVO) throws SQLException;
	public void insertTravelInfo(TravelInfoVO tVO) throws SQLException;
	public void insertPlaceImage(TravelImageVO imgVO) throws SQLException;
	public void insertPlaceVacancy(TravelVacancyVO vacancyVO) throws SQLException;
	public void insertPlaceFr(TravelFrVO frVO) throws SQLException;
	public void insertPlaceNotice(TravelInfoVO tVO) throws SQLException;
	public void insertPlaceComment(TravelCommentVO commentVO) throws SQLException;
	public void insertTravelInfoRecommend(TravelCommentVO commentVO) throws SQLException;
	// output - input전 있는지 값 확인
	public List<TravelZoneVO> findTravelZoneList() throws SQLException;
	public List<String> findTravelPlaceList(int locationid) throws SQLException;
	public List<String> getPlaceImageList(String place) throws SQLException;
	public List<String> isPlaceVacancy(String place) throws SQLException;
	public List<String> isPlaceFr(String place) throws SQLException;
	public String isPlaceNotice(String place) throws SQLException;
}
